<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `fanwe_supplier_location_order`;");
E_C("CREATE TABLE `fanwe_supplier_location_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(50) NOT NULL,
  `sid` int(11) NOT NULL,
  `order_time` int(11) NOT NULL,
  `order_nums` int(11) NOT NULL,
  `seat_status` tinyint(1) NOT NULL,
  `min_expense` int(11) NOT NULL,
  `seat_switch` tinyint(1) NOT NULL,
  `order_tel` varchar(100) NOT NULL,
  `order_name` varchar(20) NOT NULL,
  `order_sex` tinyint(1) NOT NULL,
  `order_other_tel` varchar(100) NOT NULL,
  `order_other_name` varchar(20) NOT NULL,
  `order_other_sex` tinyint(4) NOT NULL,
  `extra_serve` int(11) NOT NULL,
  `order_msg` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL COMMENT '0处理中，1等待就餐，2成功就餐，3退订成功，4订单失败',
  `create_time` int(11) NOT NULL,
  `order_tip` varchar(255) NOT NULL,
  `order_money` varchar(20) NOT NULL,
  `order_sms_type` tinyint(1) NOT NULL,
  `order_email_type` tinyint(1) unsigned NOT NULL,
  `order_sms_tel` text NOT NULL,
  `order_email_address` text NOT NULL,
  `order_sms_message` text NOT NULL,
  `order_email_message` text NOT NULL,
  `deal_type` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `order_sn` (`order_sn`),
  KEY `sid` (`sid`),
  KEY `user_id` (`user_id`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8");
E_D("replace into `fanwe_supplier_location_order` values('1','2013030512273878','2','1362420900','11','0','0','0','15888888888','盛世源码社区','1','','','0','0','本程序由盛世源码社区www.9upp.com|vip.9upp.com|www.9upp.com提供,更多极品商业源码,就在盛世源码社区vip服务:vip.9upp.com','48','2','1362385658','','111','0','0','','','','','0');");
E_D("replace into `fanwe_supplier_location_order` values('2','2013030512283540','2','1362420900','1','1','-1','0','18888888888','www.9upp.com','1','','','0','0','本程序由盛世源码社区www.9upp.com|vip.9upp.com|www.9upp.com提供,更多极品商业源码,就在盛世源码社区vip服务:vip.9upp.com','48','2','1362385715','','222','0','0','','','','','0');");
E_D("replace into `fanwe_supplier_location_order` values('3','2013030512290087','2','1362420900','1','0','0','0','15888888888','www.9upp.com','1','','','0','0','本程序由盛世源码社区www.9upp.com|vip.9upp.com|www.9upp.com提供,更多极品商业源码,就在盛世源码社区vip服务:vip.9upp.com','48','2','1362385740','','32','0','0','','','','','0');");

require("../../inc/footer.php");
?>